package com.autohome.wz.business.order.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderdetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderdetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrdernumIsNull() {
            addCriterion("ordernum is null");
            return (Criteria) this;
        }

        public Criteria andOrdernumIsNotNull() {
            addCriterion("ordernum is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernumEqualTo(String value) {
            addCriterion("ordernum =", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotEqualTo(String value) {
            addCriterion("ordernum <>", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumGreaterThan(String value) {
            addCriterion("ordernum >", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumGreaterThanOrEqualTo(String value) {
            addCriterion("ordernum >=", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLessThan(String value) {
            addCriterion("ordernum <", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLessThanOrEqualTo(String value) {
            addCriterion("ordernum <=", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLike(String value) {
            addCriterion("ordernum like", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotLike(String value) {
            addCriterion("ordernum not like", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumIn(List<String> values) {
            addCriterion("ordernum in", values, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotIn(List<String> values) {
            addCriterion("ordernum not in", values, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumBetween(String value1, String value2) {
            addCriterion("ordernum between", value1, value2, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotBetween(String value1, String value2) {
            addCriterion("ordernum not between", value1, value2, "ordernum");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNull() {
            addCriterion("productname is null");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNotNull() {
            addCriterion("productname is not null");
            return (Criteria) this;
        }

        public Criteria andProductnameEqualTo(String value) {
            addCriterion("productname =", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotEqualTo(String value) {
            addCriterion("productname <>", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThan(String value) {
            addCriterion("productname >", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThanOrEqualTo(String value) {
            addCriterion("productname >=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThan(String value) {
            addCriterion("productname <", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThanOrEqualTo(String value) {
            addCriterion("productname <=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLike(String value) {
            addCriterion("productname like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotLike(String value) {
            addCriterion("productname not like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameIn(List<String> values) {
            addCriterion("productname in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotIn(List<String> values) {
            addCriterion("productname not in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameBetween(String value1, String value2) {
            addCriterion("productname between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotBetween(String value1, String value2) {
            addCriterion("productname not between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andCountIsNull() {
            addCriterion("count is null");
            return (Criteria) this;
        }

        public Criteria andCountIsNotNull() {
            addCriterion("count is not null");
            return (Criteria) this;
        }

        public Criteria andCountEqualTo(Integer value) {
            addCriterion("count =", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotEqualTo(Integer value) {
            addCriterion("count <>", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountGreaterThan(Integer value) {
            addCriterion("count >", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("count >=", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLessThan(Integer value) {
            addCriterion("count <", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLessThanOrEqualTo(Integer value) {
            addCriterion("count <=", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountIn(List<Integer> values) {
            addCriterion("count in", values, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotIn(List<Integer> values) {
            addCriterion("count not in", values, "count");
            return (Criteria) this;
        }

        public Criteria andCountBetween(Integer value1, Integer value2) {
            addCriterion("count between", value1, value2, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotBetween(Integer value1, Integer value2) {
            addCriterion("count not between", value1, value2, "count");
            return (Criteria) this;
        }

        public Criteria andUnitpriceIsNull() {
            addCriterion("unitprice is null");
            return (Criteria) this;
        }

        public Criteria andUnitpriceIsNotNull() {
            addCriterion("unitprice is not null");
            return (Criteria) this;
        }

        public Criteria andUnitpriceEqualTo(BigDecimal value) {
            addCriterion("unitprice =", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceNotEqualTo(BigDecimal value) {
            addCriterion("unitprice <>", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceGreaterThan(BigDecimal value) {
            addCriterion("unitprice >", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("unitprice >=", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceLessThan(BigDecimal value) {
            addCriterion("unitprice <", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("unitprice <=", value, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceIn(List<BigDecimal> values) {
            addCriterion("unitprice in", values, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceNotIn(List<BigDecimal> values) {
            addCriterion("unitprice not in", values, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unitprice between", value1, value2, "unitprice");
            return (Criteria) this;
        }

        public Criteria andUnitpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unitprice not between", value1, value2, "unitprice");
            return (Criteria) this;
        }

        public Criteria andActualpaymentIsNull() {
            addCriterion("actualpayment is null");
            return (Criteria) this;
        }

        public Criteria andActualpaymentIsNotNull() {
            addCriterion("actualpayment is not null");
            return (Criteria) this;
        }

        public Criteria andActualpaymentEqualTo(BigDecimal value) {
            addCriterion("actualpayment =", value, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentNotEqualTo(BigDecimal value) {
            addCriterion("actualpayment <>", value, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentGreaterThan(BigDecimal value) {
            addCriterion("actualpayment >", value, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("actualpayment >=", value, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentLessThan(BigDecimal value) {
            addCriterion("actualpayment <", value, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentLessThanOrEqualTo(BigDecimal value) {
            addCriterion("actualpayment <=", value, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentIn(List<BigDecimal> values) {
            addCriterion("actualpayment in", values, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentNotIn(List<BigDecimal> values) {
            addCriterion("actualpayment not in", values, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("actualpayment between", value1, value2, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andActualpaymentNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("actualpayment not between", value1, value2, "actualpayment");
            return (Criteria) this;
        }

        public Criteria andOthercostsIsNull() {
            addCriterion("othercosts is null");
            return (Criteria) this;
        }

        public Criteria andOthercostsIsNotNull() {
            addCriterion("othercosts is not null");
            return (Criteria) this;
        }

        public Criteria andOthercostsEqualTo(BigDecimal value) {
            addCriterion("othercosts =", value, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsNotEqualTo(BigDecimal value) {
            addCriterion("othercosts <>", value, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsGreaterThan(BigDecimal value) {
            addCriterion("othercosts >", value, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("othercosts >=", value, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsLessThan(BigDecimal value) {
            addCriterion("othercosts <", value, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("othercosts <=", value, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsIn(List<BigDecimal> values) {
            addCriterion("othercosts in", values, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsNotIn(List<BigDecimal> values) {
            addCriterion("othercosts not in", values, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("othercosts between", value1, value2, "othercosts");
            return (Criteria) this;
        }

        public Criteria andOthercostsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("othercosts not between", value1, value2, "othercosts");
            return (Criteria) this;
        }

        public Criteria andPreferentialIsNull() {
            addCriterion("preferential is null");
            return (Criteria) this;
        }

        public Criteria andPreferentialIsNotNull() {
            addCriterion("preferential is not null");
            return (Criteria) this;
        }

        public Criteria andPreferentialEqualTo(String value) {
            addCriterion("preferential =", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialNotEqualTo(String value) {
            addCriterion("preferential <>", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialGreaterThan(String value) {
            addCriterion("preferential >", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialGreaterThanOrEqualTo(String value) {
            addCriterion("preferential >=", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialLessThan(String value) {
            addCriterion("preferential <", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialLessThanOrEqualTo(String value) {
            addCriterion("preferential <=", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialLike(String value) {
            addCriterion("preferential like", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialNotLike(String value) {
            addCriterion("preferential not like", value, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialIn(List<String> values) {
            addCriterion("preferential in", values, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialNotIn(List<String> values) {
            addCriterion("preferential not in", values, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialBetween(String value1, String value2) {
            addCriterion("preferential between", value1, value2, "preferential");
            return (Criteria) this;
        }

        public Criteria andPreferentialNotBetween(String value1, String value2) {
            addCriterion("preferential not between", value1, value2, "preferential");
            return (Criteria) this;
        }

        public Criteria andProductDetailIsNull() {
            addCriterion("product_detail is null");
            return (Criteria) this;
        }

        public Criteria andProductDetailIsNotNull() {
            addCriterion("product_detail is not null");
            return (Criteria) this;
        }

        public Criteria andProductDetailEqualTo(String value) {
            addCriterion("product_detail =", value, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailNotEqualTo(String value) {
            addCriterion("product_detail <>", value, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailGreaterThan(String value) {
            addCriterion("product_detail >", value, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailGreaterThanOrEqualTo(String value) {
            addCriterion("product_detail >=", value, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailLessThan(String value) {
            addCriterion("product_detail <", value, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailLessThanOrEqualTo(String value) {
            addCriterion("product_detail <=", value, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailLike(String value) {
            addCriterion("product_detail like", value, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailNotLike(String value) {
            addCriterion("product_detail not like", value, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailIn(List<String> values) {
            addCriterion("product_detail in", values, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailNotIn(List<String> values) {
            addCriterion("product_detail not in", values, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailBetween(String value1, String value2) {
            addCriterion("product_detail between", value1, value2, "productDetail");
            return (Criteria) this;
        }

        public Criteria andProductDetailNotBetween(String value1, String value2) {
            addCriterion("product_detail not between", value1, value2, "productDetail");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoIsNull() {
            addCriterion("additional_info is null");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoIsNotNull() {
            addCriterion("additional_info is not null");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoEqualTo(String value) {
            addCriterion("additional_info =", value, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoNotEqualTo(String value) {
            addCriterion("additional_info <>", value, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoGreaterThan(String value) {
            addCriterion("additional_info >", value, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoGreaterThanOrEqualTo(String value) {
            addCriterion("additional_info >=", value, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoLessThan(String value) {
            addCriterion("additional_info <", value, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoLessThanOrEqualTo(String value) {
            addCriterion("additional_info <=", value, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoLike(String value) {
            addCriterion("additional_info like", value, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoNotLike(String value) {
            addCriterion("additional_info not like", value, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoIn(List<String> values) {
            addCriterion("additional_info in", values, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoNotIn(List<String> values) {
            addCriterion("additional_info not in", values, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoBetween(String value1, String value2) {
            addCriterion("additional_info between", value1, value2, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoNotBetween(String value1, String value2) {
            addCriterion("additional_info not between", value1, value2, "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andRelObjIdIsNull() {
            addCriterion("rel_obj_id is null");
            return (Criteria) this;
        }

        public Criteria andRelObjIdIsNotNull() {
            addCriterion("rel_obj_id is not null");
            return (Criteria) this;
        }

        public Criteria andRelObjIdEqualTo(Integer value) {
            addCriterion("rel_obj_id =", value, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdNotEqualTo(Integer value) {
            addCriterion("rel_obj_id <>", value, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdGreaterThan(Integer value) {
            addCriterion("rel_obj_id >", value, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("rel_obj_id >=", value, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdLessThan(Integer value) {
            addCriterion("rel_obj_id <", value, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdLessThanOrEqualTo(Integer value) {
            addCriterion("rel_obj_id <=", value, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdIn(List<Integer> values) {
            addCriterion("rel_obj_id in", values, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdNotIn(List<Integer> values) {
            addCriterion("rel_obj_id not in", values, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdBetween(Integer value1, Integer value2) {
            addCriterion("rel_obj_id between", value1, value2, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjIdNotBetween(Integer value1, Integer value2) {
            addCriterion("rel_obj_id not between", value1, value2, "relObjId");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeIsNull() {
            addCriterion("rel_obj_type is null");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeIsNotNull() {
            addCriterion("rel_obj_type is not null");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeEqualTo(Integer value) {
            addCriterion("rel_obj_type =", value, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeNotEqualTo(Integer value) {
            addCriterion("rel_obj_type <>", value, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeGreaterThan(Integer value) {
            addCriterion("rel_obj_type >", value, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("rel_obj_type >=", value, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeLessThan(Integer value) {
            addCriterion("rel_obj_type <", value, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeLessThanOrEqualTo(Integer value) {
            addCriterion("rel_obj_type <=", value, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeIn(List<Integer> values) {
            addCriterion("rel_obj_type in", values, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeNotIn(List<Integer> values) {
            addCriterion("rel_obj_type not in", values, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeBetween(Integer value1, Integer value2) {
            addCriterion("rel_obj_type between", value1, value2, "relObjType");
            return (Criteria) this;
        }

        public Criteria andRelObjTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("rel_obj_type not between", value1, value2, "relObjType");
            return (Criteria) this;
        }

        public Criteria andBuyeridIsNull() {
            addCriterion("buyerid is null");
            return (Criteria) this;
        }

        public Criteria andBuyeridIsNotNull() {
            addCriterion("buyerid is not null");
            return (Criteria) this;
        }

        public Criteria andBuyeridEqualTo(Integer value) {
            addCriterion("buyerid =", value, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridNotEqualTo(Integer value) {
            addCriterion("buyerid <>", value, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridGreaterThan(Integer value) {
            addCriterion("buyerid >", value, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridGreaterThanOrEqualTo(Integer value) {
            addCriterion("buyerid >=", value, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridLessThan(Integer value) {
            addCriterion("buyerid <", value, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridLessThanOrEqualTo(Integer value) {
            addCriterion("buyerid <=", value, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridIn(List<Integer> values) {
            addCriterion("buyerid in", values, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridNotIn(List<Integer> values) {
            addCriterion("buyerid not in", values, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridBetween(Integer value1, Integer value2) {
            addCriterion("buyerid between", value1, value2, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuyeridNotBetween(Integer value1, Integer value2) {
            addCriterion("buyerid not between", value1, value2, "buyerid");
            return (Criteria) this;
        }

        public Criteria andBuytimeIsNull() {
            addCriterion("buytime is null");
            return (Criteria) this;
        }

        public Criteria andBuytimeIsNotNull() {
            addCriterion("buytime is not null");
            return (Criteria) this;
        }

        public Criteria andBuytimeEqualTo(Date value) {
            addCriterion("buytime =", value, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeNotEqualTo(Date value) {
            addCriterion("buytime <>", value, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeGreaterThan(Date value) {
            addCriterion("buytime >", value, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("buytime >=", value, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeLessThan(Date value) {
            addCriterion("buytime <", value, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeLessThanOrEqualTo(Date value) {
            addCriterion("buytime <=", value, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeIn(List<Date> values) {
            addCriterion("buytime in", values, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeNotIn(List<Date> values) {
            addCriterion("buytime not in", values, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeBetween(Date value1, Date value2) {
            addCriterion("buytime between", value1, value2, "buytime");
            return (Criteria) this;
        }

        public Criteria andBuytimeNotBetween(Date value1, Date value2) {
            addCriterion("buytime not between", value1, value2, "buytime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andIdcodeIsNull() {
            addCriterion("idcode is null");
            return (Criteria) this;
        }

        public Criteria andIdcodeIsNotNull() {
            addCriterion("idcode is not null");
            return (Criteria) this;
        }

        public Criteria andIdcodeEqualTo(String value) {
            addCriterion("idcode =", value, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeNotEqualTo(String value) {
            addCriterion("idcode <>", value, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeGreaterThan(String value) {
            addCriterion("idcode >", value, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeGreaterThanOrEqualTo(String value) {
            addCriterion("idcode >=", value, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeLessThan(String value) {
            addCriterion("idcode <", value, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeLessThanOrEqualTo(String value) {
            addCriterion("idcode <=", value, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeLike(String value) {
            addCriterion("idcode like", value, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeNotLike(String value) {
            addCriterion("idcode not like", value, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeIn(List<String> values) {
            addCriterion("idcode in", values, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeNotIn(List<String> values) {
            addCriterion("idcode not in", values, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeBetween(String value1, String value2) {
            addCriterion("idcode between", value1, value2, "idcode");
            return (Criteria) this;
        }

        public Criteria andIdcodeNotBetween(String value1, String value2) {
            addCriterion("idcode not between", value1, value2, "idcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeIsNull() {
            addCriterion("pidcode is null");
            return (Criteria) this;
        }

        public Criteria andPidcodeIsNotNull() {
            addCriterion("pidcode is not null");
            return (Criteria) this;
        }

        public Criteria andPidcodeEqualTo(String value) {
            addCriterion("pidcode =", value, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeNotEqualTo(String value) {
            addCriterion("pidcode <>", value, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeGreaterThan(String value) {
            addCriterion("pidcode >", value, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeGreaterThanOrEqualTo(String value) {
            addCriterion("pidcode >=", value, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeLessThan(String value) {
            addCriterion("pidcode <", value, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeLessThanOrEqualTo(String value) {
            addCriterion("pidcode <=", value, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeLike(String value) {
            addCriterion("pidcode like", value, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeNotLike(String value) {
            addCriterion("pidcode not like", value, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeIn(List<String> values) {
            addCriterion("pidcode in", values, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeNotIn(List<String> values) {
            addCriterion("pidcode not in", values, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeBetween(String value1, String value2) {
            addCriterion("pidcode between", value1, value2, "pidcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeNotBetween(String value1, String value2) {
            addCriterion("pidcode not between", value1, value2, "pidcode");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andSelleridIsNull() {
            addCriterion("sellerid is null");
            return (Criteria) this;
        }

        public Criteria andSelleridIsNotNull() {
            addCriterion("sellerid is not null");
            return (Criteria) this;
        }

        public Criteria andSelleridEqualTo(Integer value) {
            addCriterion("sellerid =", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridNotEqualTo(Integer value) {
            addCriterion("sellerid <>", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridGreaterThan(Integer value) {
            addCriterion("sellerid >", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridGreaterThanOrEqualTo(Integer value) {
            addCriterion("sellerid >=", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridLessThan(Integer value) {
            addCriterion("sellerid <", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridLessThanOrEqualTo(Integer value) {
            addCriterion("sellerid <=", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridIn(List<Integer> values) {
            addCriterion("sellerid in", values, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridNotIn(List<Integer> values) {
            addCriterion("sellerid not in", values, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridBetween(Integer value1, Integer value2) {
            addCriterion("sellerid between", value1, value2, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridNotBetween(Integer value1, Integer value2) {
            addCriterion("sellerid not between", value1, value2, "sellerid");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeIsNull() {
            addCriterion("ext_idcode is null");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeIsNotNull() {
            addCriterion("ext_idcode is not null");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeEqualTo(String value) {
            addCriterion("ext_idcode =", value, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeNotEqualTo(String value) {
            addCriterion("ext_idcode <>", value, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeGreaterThan(String value) {
            addCriterion("ext_idcode >", value, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ext_idcode >=", value, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeLessThan(String value) {
            addCriterion("ext_idcode <", value, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeLessThanOrEqualTo(String value) {
            addCriterion("ext_idcode <=", value, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeLike(String value) {
            addCriterion("ext_idcode like", value, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeNotLike(String value) {
            addCriterion("ext_idcode not like", value, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeIn(List<String> values) {
            addCriterion("ext_idcode in", values, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeNotIn(List<String> values) {
            addCriterion("ext_idcode not in", values, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeBetween(String value1, String value2) {
            addCriterion("ext_idcode between", value1, value2, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeNotBetween(String value1, String value2) {
            addCriterion("ext_idcode not between", value1, value2, "extIdcode");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdIsNull() {
            addCriterion("seller_settings_id is null");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdIsNotNull() {
            addCriterion("seller_settings_id is not null");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdEqualTo(Integer value) {
            addCriterion("seller_settings_id =", value, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdNotEqualTo(Integer value) {
            addCriterion("seller_settings_id <>", value, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdGreaterThan(Integer value) {
            addCriterion("seller_settings_id >", value, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("seller_settings_id >=", value, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdLessThan(Integer value) {
            addCriterion("seller_settings_id <", value, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdLessThanOrEqualTo(Integer value) {
            addCriterion("seller_settings_id <=", value, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdIn(List<Integer> values) {
            addCriterion("seller_settings_id in", values, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdNotIn(List<Integer> values) {
            addCriterion("seller_settings_id not in", values, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdBetween(Integer value1, Integer value2) {
            addCriterion("seller_settings_id between", value1, value2, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSellerSettingsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("seller_settings_id not between", value1, value2, "sellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusIsNull() {
            addCriterion("settle_accounts_status is null");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusIsNotNull() {
            addCriterion("settle_accounts_status is not null");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusEqualTo(Integer value) {
            addCriterion("settle_accounts_status =", value, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusNotEqualTo(Integer value) {
            addCriterion("settle_accounts_status <>", value, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusGreaterThan(Integer value) {
            addCriterion("settle_accounts_status >", value, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("settle_accounts_status >=", value, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusLessThan(Integer value) {
            addCriterion("settle_accounts_status <", value, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusLessThanOrEqualTo(Integer value) {
            addCriterion("settle_accounts_status <=", value, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusIn(List<Integer> values) {
            addCriterion("settle_accounts_status in", values, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusNotIn(List<Integer> values) {
            addCriterion("settle_accounts_status not in", values, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusBetween(Integer value1, Integer value2) {
            addCriterion("settle_accounts_status between", value1, value2, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSettleAccountsStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("settle_accounts_status not between", value1, value2, "settleAccountsStatus");
            return (Criteria) this;
        }

        public Criteria andSubordernumIsNull() {
            addCriterion("subordernum is null");
            return (Criteria) this;
        }

        public Criteria andSubordernumIsNotNull() {
            addCriterion("subordernum is not null");
            return (Criteria) this;
        }

        public Criteria andSubordernumEqualTo(String value) {
            addCriterion("subordernum =", value, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumNotEqualTo(String value) {
            addCriterion("subordernum <>", value, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumGreaterThan(String value) {
            addCriterion("subordernum >", value, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumGreaterThanOrEqualTo(String value) {
            addCriterion("subordernum >=", value, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumLessThan(String value) {
            addCriterion("subordernum <", value, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumLessThanOrEqualTo(String value) {
            addCriterion("subordernum <=", value, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumLike(String value) {
            addCriterion("subordernum like", value, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumNotLike(String value) {
            addCriterion("subordernum not like", value, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumIn(List<String> values) {
            addCriterion("subordernum in", values, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumNotIn(List<String> values) {
            addCriterion("subordernum not in", values, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumBetween(String value1, String value2) {
            addCriterion("subordernum between", value1, value2, "subordernum");
            return (Criteria) this;
        }

        public Criteria andSubordernumNotBetween(String value1, String value2) {
            addCriterion("subordernum not between", value1, value2, "subordernum");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeIsNull() {
            addCriterion("finishedtime is null");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeIsNotNull() {
            addCriterion("finishedtime is not null");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeEqualTo(Date value) {
            addCriterion("finishedtime =", value, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeNotEqualTo(Date value) {
            addCriterion("finishedtime <>", value, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeGreaterThan(Date value) {
            addCriterion("finishedtime >", value, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("finishedtime >=", value, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeLessThan(Date value) {
            addCriterion("finishedtime <", value, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeLessThanOrEqualTo(Date value) {
            addCriterion("finishedtime <=", value, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeIn(List<Date> values) {
            addCriterion("finishedtime in", values, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeNotIn(List<Date> values) {
            addCriterion("finishedtime not in", values, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeBetween(Date value1, Date value2) {
            addCriterion("finishedtime between", value1, value2, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andFinishedtimeNotBetween(Date value1, Date value2) {
            addCriterion("finishedtime not between", value1, value2, "finishedtime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoIsNull() {
            addCriterion("ext_additional_info is null");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoIsNotNull() {
            addCriterion("ext_additional_info is not null");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoEqualTo(String value) {
            addCriterion("ext_additional_info =", value, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoNotEqualTo(String value) {
            addCriterion("ext_additional_info <>", value, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoGreaterThan(String value) {
            addCriterion("ext_additional_info >", value, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoGreaterThanOrEqualTo(String value) {
            addCriterion("ext_additional_info >=", value, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoLessThan(String value) {
            addCriterion("ext_additional_info <", value, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoLessThanOrEqualTo(String value) {
            addCriterion("ext_additional_info <=", value, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoLike(String value) {
            addCriterion("ext_additional_info like", value, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoNotLike(String value) {
            addCriterion("ext_additional_info not like", value, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoIn(List<String> values) {
            addCriterion("ext_additional_info in", values, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoNotIn(List<String> values) {
            addCriterion("ext_additional_info not in", values, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoBetween(String value1, String value2) {
            addCriterion("ext_additional_info between", value1, value2, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoNotBetween(String value1, String value2) {
            addCriterion("ext_additional_info not between", value1, value2, "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeIsNull() {
            addCriterion("processing_time is null");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeIsNotNull() {
            addCriterion("processing_time is not null");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeEqualTo(Date value) {
            addCriterion("processing_time =", value, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeNotEqualTo(Date value) {
            addCriterion("processing_time <>", value, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeGreaterThan(Date value) {
            addCriterion("processing_time >", value, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("processing_time >=", value, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeLessThan(Date value) {
            addCriterion("processing_time <", value, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeLessThanOrEqualTo(Date value) {
            addCriterion("processing_time <=", value, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeIn(List<Date> values) {
            addCriterion("processing_time in", values, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeNotIn(List<Date> values) {
            addCriterion("processing_time not in", values, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeBetween(Date value1, Date value2) {
            addCriterion("processing_time between", value1, value2, "processingTime");
            return (Criteria) this;
        }

        public Criteria andProcessingTimeNotBetween(Date value1, Date value2) {
            addCriterion("processing_time not between", value1, value2, "processingTime");
            return (Criteria) this;
        }

        public Criteria andExstatusIsNull() {
            addCriterion("exstatus is null");
            return (Criteria) this;
        }

        public Criteria andExstatusIsNotNull() {
            addCriterion("exstatus is not null");
            return (Criteria) this;
        }

        public Criteria andExstatusEqualTo(Integer value) {
            addCriterion("exstatus =", value, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusNotEqualTo(Integer value) {
            addCriterion("exstatus <>", value, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusGreaterThan(Integer value) {
            addCriterion("exstatus >", value, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("exstatus >=", value, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusLessThan(Integer value) {
            addCriterion("exstatus <", value, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusLessThanOrEqualTo(Integer value) {
            addCriterion("exstatus <=", value, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusIn(List<Integer> values) {
            addCriterion("exstatus in", values, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusNotIn(List<Integer> values) {
            addCriterion("exstatus not in", values, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusBetween(Integer value1, Integer value2) {
            addCriterion("exstatus between", value1, value2, "exstatus");
            return (Criteria) this;
        }

        public Criteria andExstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("exstatus not between", value1, value2, "exstatus");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerIsNull() {
            addCriterion("settle_paypartner is null");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerIsNotNull() {
            addCriterion("settle_paypartner is not null");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerEqualTo(BigDecimal value) {
            addCriterion("settle_paypartner =", value, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerNotEqualTo(BigDecimal value) {
            addCriterion("settle_paypartner <>", value, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerGreaterThan(BigDecimal value) {
            addCriterion("settle_paypartner >", value, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("settle_paypartner >=", value, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerLessThan(BigDecimal value) {
            addCriterion("settle_paypartner <", value, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerLessThanOrEqualTo(BigDecimal value) {
            addCriterion("settle_paypartner <=", value, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerIn(List<BigDecimal> values) {
            addCriterion("settle_paypartner in", values, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerNotIn(List<BigDecimal> values) {
            addCriterion("settle_paypartner not in", values, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settle_paypartner between", value1, value2, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettlePaypartnerNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settle_paypartner not between", value1, value2, "settlePaypartner");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsIsNull() {
            addCriterion("settle_othercosts is null");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsIsNotNull() {
            addCriterion("settle_othercosts is not null");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsEqualTo(BigDecimal value) {
            addCriterion("settle_othercosts =", value, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsNotEqualTo(BigDecimal value) {
            addCriterion("settle_othercosts <>", value, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsGreaterThan(BigDecimal value) {
            addCriterion("settle_othercosts >", value, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("settle_othercosts >=", value, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsLessThan(BigDecimal value) {
            addCriterion("settle_othercosts <", value, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("settle_othercosts <=", value, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsIn(List<BigDecimal> values) {
            addCriterion("settle_othercosts in", values, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsNotIn(List<BigDecimal> values) {
            addCriterion("settle_othercosts not in", values, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settle_othercosts between", value1, value2, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andSettleOthercostsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settle_othercosts not between", value1, value2, "settleOthercosts");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridIsNull() {
            addCriterion("first_sellerid is null");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridIsNotNull() {
            addCriterion("first_sellerid is not null");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridEqualTo(Integer value) {
            addCriterion("first_sellerid =", value, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridNotEqualTo(Integer value) {
            addCriterion("first_sellerid <>", value, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridGreaterThan(Integer value) {
            addCriterion("first_sellerid >", value, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridGreaterThanOrEqualTo(Integer value) {
            addCriterion("first_sellerid >=", value, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridLessThan(Integer value) {
            addCriterion("first_sellerid <", value, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridLessThanOrEqualTo(Integer value) {
            addCriterion("first_sellerid <=", value, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridIn(List<Integer> values) {
            addCriterion("first_sellerid in", values, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridNotIn(List<Integer> values) {
            addCriterion("first_sellerid not in", values, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridBetween(Integer value1, Integer value2) {
            addCriterion("first_sellerid between", value1, value2, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSelleridNotBetween(Integer value1, Integer value2) {
            addCriterion("first_sellerid not between", value1, value2, "firstSellerid");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdIsNull() {
            addCriterion("first_seller_settings_id is null");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdIsNotNull() {
            addCriterion("first_seller_settings_id is not null");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdEqualTo(Integer value) {
            addCriterion("first_seller_settings_id =", value, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdNotEqualTo(Integer value) {
            addCriterion("first_seller_settings_id <>", value, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdGreaterThan(Integer value) {
            addCriterion("first_seller_settings_id >", value, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("first_seller_settings_id >=", value, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdLessThan(Integer value) {
            addCriterion("first_seller_settings_id <", value, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdLessThanOrEqualTo(Integer value) {
            addCriterion("first_seller_settings_id <=", value, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdIn(List<Integer> values) {
            addCriterion("first_seller_settings_id in", values, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdNotIn(List<Integer> values) {
            addCriterion("first_seller_settings_id not in", values, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdBetween(Integer value1, Integer value2) {
            addCriterion("first_seller_settings_id between", value1, value2, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andFirstSellerSettingsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("first_seller_settings_id not between", value1, value2, "firstSellerSettingsId");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampIsNull() {
            addCriterion("updatetimestamp is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampIsNotNull() {
            addCriterion("updatetimestamp is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampEqualTo(Long value) {
            addCriterion("updatetimestamp =", value, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampNotEqualTo(Long value) {
            addCriterion("updatetimestamp <>", value, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampGreaterThan(Long value) {
            addCriterion("updatetimestamp >", value, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampGreaterThanOrEqualTo(Long value) {
            addCriterion("updatetimestamp >=", value, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampLessThan(Long value) {
            addCriterion("updatetimestamp <", value, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampLessThanOrEqualTo(Long value) {
            addCriterion("updatetimestamp <=", value, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampIn(List<Long> values) {
            addCriterion("updatetimestamp in", values, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampNotIn(List<Long> values) {
            addCriterion("updatetimestamp not in", values, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampBetween(Long value1, Long value2) {
            addCriterion("updatetimestamp between", value1, value2, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andUpdatetimestampNotBetween(Long value1, Long value2) {
            addCriterion("updatetimestamp not between", value1, value2, "updatetimestamp");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdIsNull() {
            addCriterion("order_express_info_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdIsNotNull() {
            addCriterion("order_express_info_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdEqualTo(Integer value) {
            addCriterion("order_express_info_id =", value, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdNotEqualTo(Integer value) {
            addCriterion("order_express_info_id <>", value, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdGreaterThan(Integer value) {
            addCriterion("order_express_info_id >", value, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_express_info_id >=", value, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdLessThan(Integer value) {
            addCriterion("order_express_info_id <", value, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdLessThanOrEqualTo(Integer value) {
            addCriterion("order_express_info_id <=", value, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdIn(List<Integer> values) {
            addCriterion("order_express_info_id in", values, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdNotIn(List<Integer> values) {
            addCriterion("order_express_info_id not in", values, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdBetween(Integer value1, Integer value2) {
            addCriterion("order_express_info_id between", value1, value2, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andOrderExpressInfoIdNotBetween(Integer value1, Integer value2) {
            addCriterion("order_express_info_id not between", value1, value2, "orderExpressInfoId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdIsNull() {
            addCriterion("tech_parnter_id is null");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdIsNotNull() {
            addCriterion("tech_parnter_id is not null");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdEqualTo(Integer value) {
            addCriterion("tech_parnter_id =", value, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdNotEqualTo(Integer value) {
            addCriterion("tech_parnter_id <>", value, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdGreaterThan(Integer value) {
            addCriterion("tech_parnter_id >", value, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("tech_parnter_id >=", value, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdLessThan(Integer value) {
            addCriterion("tech_parnter_id <", value, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdLessThanOrEqualTo(Integer value) {
            addCriterion("tech_parnter_id <=", value, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdIn(List<Integer> values) {
            addCriterion("tech_parnter_id in", values, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdNotIn(List<Integer> values) {
            addCriterion("tech_parnter_id not in", values, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdBetween(Integer value1, Integer value2) {
            addCriterion("tech_parnter_id between", value1, value2, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andTechParnterIdNotBetween(Integer value1, Integer value2) {
            addCriterion("tech_parnter_id not between", value1, value2, "techParnterId");
            return (Criteria) this;
        }

        public Criteria andParvalueIsNull() {
            addCriterion("parvalue is null");
            return (Criteria) this;
        }

        public Criteria andParvalueIsNotNull() {
            addCriterion("parvalue is not null");
            return (Criteria) this;
        }

        public Criteria andParvalueEqualTo(BigDecimal value) {
            addCriterion("parvalue =", value, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueNotEqualTo(BigDecimal value) {
            addCriterion("parvalue <>", value, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueGreaterThan(BigDecimal value) {
            addCriterion("parvalue >", value, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("parvalue >=", value, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueLessThan(BigDecimal value) {
            addCriterion("parvalue <", value, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("parvalue <=", value, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueIn(List<BigDecimal> values) {
            addCriterion("parvalue in", values, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueNotIn(List<BigDecimal> values) {
            addCriterion("parvalue not in", values, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("parvalue between", value1, value2, "parvalue");
            return (Criteria) this;
        }

        public Criteria andParvalueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("parvalue not between", value1, value2, "parvalue");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusIsNull() {
            addCriterion("order_cost_status is null");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusIsNotNull() {
            addCriterion("order_cost_status is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusEqualTo(Integer value) {
            addCriterion("order_cost_status =", value, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusNotEqualTo(Integer value) {
            addCriterion("order_cost_status <>", value, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusGreaterThan(Integer value) {
            addCriterion("order_cost_status >", value, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_cost_status >=", value, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusLessThan(Integer value) {
            addCriterion("order_cost_status <", value, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusLessThanOrEqualTo(Integer value) {
            addCriterion("order_cost_status <=", value, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusIn(List<Integer> values) {
            addCriterion("order_cost_status in", values, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusNotIn(List<Integer> values) {
            addCriterion("order_cost_status not in", values, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusBetween(Integer value1, Integer value2) {
            addCriterion("order_cost_status between", value1, value2, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andOrderCostStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("order_cost_status not between", value1, value2, "orderCostStatus");
            return (Criteria) this;
        }

        public Criteria andPriceidIsNull() {
            addCriterion("priceId is null");
            return (Criteria) this;
        }

        public Criteria andPriceidIsNotNull() {
            addCriterion("priceId is not null");
            return (Criteria) this;
        }

        public Criteria andPriceidEqualTo(Integer value) {
            addCriterion("priceId =", value, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidNotEqualTo(Integer value) {
            addCriterion("priceId <>", value, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidGreaterThan(Integer value) {
            addCriterion("priceId >", value, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidGreaterThanOrEqualTo(Integer value) {
            addCriterion("priceId >=", value, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidLessThan(Integer value) {
            addCriterion("priceId <", value, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidLessThanOrEqualTo(Integer value) {
            addCriterion("priceId <=", value, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidIn(List<Integer> values) {
            addCriterion("priceId in", values, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidNotIn(List<Integer> values) {
            addCriterion("priceId not in", values, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidBetween(Integer value1, Integer value2) {
            addCriterion("priceId between", value1, value2, "priceid");
            return (Criteria) this;
        }

        public Criteria andPriceidNotBetween(Integer value1, Integer value2) {
            addCriterion("priceId not between", value1, value2, "priceid");
            return (Criteria) this;
        }

        public Criteria andItemskuidIsNull() {
            addCriterion("itemSkuId is null");
            return (Criteria) this;
        }

        public Criteria andItemskuidIsNotNull() {
            addCriterion("itemSkuId is not null");
            return (Criteria) this;
        }

        public Criteria andItemskuidEqualTo(Integer value) {
            addCriterion("itemSkuId =", value, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidNotEqualTo(Integer value) {
            addCriterion("itemSkuId <>", value, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidGreaterThan(Integer value) {
            addCriterion("itemSkuId >", value, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidGreaterThanOrEqualTo(Integer value) {
            addCriterion("itemSkuId >=", value, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidLessThan(Integer value) {
            addCriterion("itemSkuId <", value, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidLessThanOrEqualTo(Integer value) {
            addCriterion("itemSkuId <=", value, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidIn(List<Integer> values) {
            addCriterion("itemSkuId in", values, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidNotIn(List<Integer> values) {
            addCriterion("itemSkuId not in", values, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidBetween(Integer value1, Integer value2) {
            addCriterion("itemSkuId between", value1, value2, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemskuidNotBetween(Integer value1, Integer value2) {
            addCriterion("itemSkuId not between", value1, value2, "itemskuid");
            return (Criteria) this;
        }

        public Criteria andItemidIsNull() {
            addCriterion("itemId is null");
            return (Criteria) this;
        }

        public Criteria andItemidIsNotNull() {
            addCriterion("itemId is not null");
            return (Criteria) this;
        }

        public Criteria andItemidEqualTo(Integer value) {
            addCriterion("itemId =", value, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidNotEqualTo(Integer value) {
            addCriterion("itemId <>", value, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidGreaterThan(Integer value) {
            addCriterion("itemId >", value, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("itemId >=", value, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidLessThan(Integer value) {
            addCriterion("itemId <", value, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidLessThanOrEqualTo(Integer value) {
            addCriterion("itemId <=", value, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidIn(List<Integer> values) {
            addCriterion("itemId in", values, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidNotIn(List<Integer> values) {
            addCriterion("itemId not in", values, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidBetween(Integer value1, Integer value2) {
            addCriterion("itemId between", value1, value2, "itemid");
            return (Criteria) this;
        }

        public Criteria andItemidNotBetween(Integer value1, Integer value2) {
            addCriterion("itemId not between", value1, value2, "itemid");
            return (Criteria) this;
        }

        public Criteria andBusinessidIsNull() {
            addCriterion("businessId is null");
            return (Criteria) this;
        }

        public Criteria andBusinessidIsNotNull() {
            addCriterion("businessId is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessidEqualTo(Integer value) {
            addCriterion("businessId =", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidNotEqualTo(Integer value) {
            addCriterion("businessId <>", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidGreaterThan(Integer value) {
            addCriterion("businessId >", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidGreaterThanOrEqualTo(Integer value) {
            addCriterion("businessId >=", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidLessThan(Integer value) {
            addCriterion("businessId <", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidLessThanOrEqualTo(Integer value) {
            addCriterion("businessId <=", value, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidIn(List<Integer> values) {
            addCriterion("businessId in", values, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidNotIn(List<Integer> values) {
            addCriterion("businessId not in", values, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidBetween(Integer value1, Integer value2) {
            addCriterion("businessId between", value1, value2, "businessid");
            return (Criteria) this;
        }

        public Criteria andBusinessidNotBetween(Integer value1, Integer value2) {
            addCriterion("businessId not between", value1, value2, "businessid");
            return (Criteria) this;
        }

        public Criteria andPlatformidIsNull() {
            addCriterion("platformId is null");
            return (Criteria) this;
        }

        public Criteria andPlatformidIsNotNull() {
            addCriterion("platformId is not null");
            return (Criteria) this;
        }

        public Criteria andPlatformidEqualTo(String value) {
            addCriterion("platformId =", value, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidNotEqualTo(String value) {
            addCriterion("platformId <>", value, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidGreaterThan(String value) {
            addCriterion("platformId >", value, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidGreaterThanOrEqualTo(String value) {
            addCriterion("platformId >=", value, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidLessThan(String value) {
            addCriterion("platformId <", value, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidLessThanOrEqualTo(String value) {
            addCriterion("platformId <=", value, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidLike(String value) {
            addCriterion("platformId like", value, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidNotLike(String value) {
            addCriterion("platformId not like", value, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidIn(List<String> values) {
            addCriterion("platformId in", values, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidNotIn(List<String> values) {
            addCriterion("platformId not in", values, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidBetween(String value1, String value2) {
            addCriterion("platformId between", value1, value2, "platformid");
            return (Criteria) this;
        }

        public Criteria andPlatformidNotBetween(String value1, String value2) {
            addCriterion("platformId not between", value1, value2, "platformid");
            return (Criteria) this;
        }

        public Criteria andSourceidIsNull() {
            addCriterion("sourceid is null");
            return (Criteria) this;
        }

        public Criteria andSourceidIsNotNull() {
            addCriterion("sourceid is not null");
            return (Criteria) this;
        }

        public Criteria andSourceidEqualTo(String value) {
            addCriterion("sourceid =", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidNotEqualTo(String value) {
            addCriterion("sourceid <>", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidGreaterThan(String value) {
            addCriterion("sourceid >", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidGreaterThanOrEqualTo(String value) {
            addCriterion("sourceid >=", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidLessThan(String value) {
            addCriterion("sourceid <", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidLessThanOrEqualTo(String value) {
            addCriterion("sourceid <=", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidLike(String value) {
            addCriterion("sourceid like", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidNotLike(String value) {
            addCriterion("sourceid not like", value, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidIn(List<String> values) {
            addCriterion("sourceid in", values, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidNotIn(List<String> values) {
            addCriterion("sourceid not in", values, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidBetween(String value1, String value2) {
            addCriterion("sourceid between", value1, value2, "sourceid");
            return (Criteria) this;
        }

        public Criteria andSourceidNotBetween(String value1, String value2) {
            addCriterion("sourceid not between", value1, value2, "sourceid");
            return (Criteria) this;
        }

        public Criteria andEnidIsNull() {
            addCriterion("enid is null");
            return (Criteria) this;
        }

        public Criteria andEnidIsNotNull() {
            addCriterion("enid is not null");
            return (Criteria) this;
        }

        public Criteria andEnidEqualTo(String value) {
            addCriterion("enid =", value, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidNotEqualTo(String value) {
            addCriterion("enid <>", value, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidGreaterThan(String value) {
            addCriterion("enid >", value, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidGreaterThanOrEqualTo(String value) {
            addCriterion("enid >=", value, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidLessThan(String value) {
            addCriterion("enid <", value, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidLessThanOrEqualTo(String value) {
            addCriterion("enid <=", value, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidLike(String value) {
            addCriterion("enid like", value, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidNotLike(String value) {
            addCriterion("enid not like", value, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidIn(List<String> values) {
            addCriterion("enid in", values, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidNotIn(List<String> values) {
            addCriterion("enid not in", values, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidBetween(String value1, String value2) {
            addCriterion("enid between", value1, value2, "enid");
            return (Criteria) this;
        }

        public Criteria andEnidNotBetween(String value1, String value2) {
            addCriterion("enid not between", value1, value2, "enid");
            return (Criteria) this;
        }

        public Criteria andCommentStatusIsNull() {
            addCriterion("comment_status is null");
            return (Criteria) this;
        }

        public Criteria andCommentStatusIsNotNull() {
            addCriterion("comment_status is not null");
            return (Criteria) this;
        }

        public Criteria andCommentStatusEqualTo(Integer value) {
            addCriterion("comment_status =", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusNotEqualTo(Integer value) {
            addCriterion("comment_status <>", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusGreaterThan(Integer value) {
            addCriterion("comment_status >", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("comment_status >=", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusLessThan(Integer value) {
            addCriterion("comment_status <", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusLessThanOrEqualTo(Integer value) {
            addCriterion("comment_status <=", value, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusIn(List<Integer> values) {
            addCriterion("comment_status in", values, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusNotIn(List<Integer> values) {
            addCriterion("comment_status not in", values, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusBetween(Integer value1, Integer value2) {
            addCriterion("comment_status between", value1, value2, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andCommentStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("comment_status not between", value1, value2, "commentStatus");
            return (Criteria) this;
        }

        public Criteria andDeviceIsNull() {
            addCriterion("device is null");
            return (Criteria) this;
        }

        public Criteria andDeviceIsNotNull() {
            addCriterion("device is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceEqualTo(String value) {
            addCriterion("device =", value, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceNotEqualTo(String value) {
            addCriterion("device <>", value, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceGreaterThan(String value) {
            addCriterion("device >", value, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceGreaterThanOrEqualTo(String value) {
            addCriterion("device >=", value, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceLessThan(String value) {
            addCriterion("device <", value, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceLessThanOrEqualTo(String value) {
            addCriterion("device <=", value, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceLike(String value) {
            addCriterion("device like", value, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceNotLike(String value) {
            addCriterion("device not like", value, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceIn(List<String> values) {
            addCriterion("device in", values, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceNotIn(List<String> values) {
            addCriterion("device not in", values, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceBetween(String value1, String value2) {
            addCriterion("device between", value1, value2, "device");
            return (Criteria) this;
        }

        public Criteria andDeviceNotBetween(String value1, String value2) {
            addCriterion("device not between", value1, value2, "device");
            return (Criteria) this;
        }

        public Criteria andOrdernumLikeInsensitive(String value) {
            addCriterion("upper(ordernum) like", value.toUpperCase(), "ordernum");
            return (Criteria) this;
        }

        public Criteria andProductnameLikeInsensitive(String value) {
            addCriterion("upper(productname) like", value.toUpperCase(), "productname");
            return (Criteria) this;
        }

        public Criteria andPreferentialLikeInsensitive(String value) {
            addCriterion("upper(preferential) like", value.toUpperCase(), "preferential");
            return (Criteria) this;
        }

        public Criteria andProductDetailLikeInsensitive(String value) {
            addCriterion("upper(product_detail) like", value.toUpperCase(), "productDetail");
            return (Criteria) this;
        }

        public Criteria andAdditionalInfoLikeInsensitive(String value) {
            addCriterion("upper(additional_info) like", value.toUpperCase(), "additionalInfo");
            return (Criteria) this;
        }

        public Criteria andIdcodeLikeInsensitive(String value) {
            addCriterion("upper(idcode) like", value.toUpperCase(), "idcode");
            return (Criteria) this;
        }

        public Criteria andPidcodeLikeInsensitive(String value) {
            addCriterion("upper(pidcode) like", value.toUpperCase(), "pidcode");
            return (Criteria) this;
        }

        public Criteria andExtIdcodeLikeInsensitive(String value) {
            addCriterion("upper(ext_idcode) like", value.toUpperCase(), "extIdcode");
            return (Criteria) this;
        }

        public Criteria andSubordernumLikeInsensitive(String value) {
            addCriterion("upper(subordernum) like", value.toUpperCase(), "subordernum");
            return (Criteria) this;
        }

        public Criteria andRemarkLikeInsensitive(String value) {
            addCriterion("upper(remark) like", value.toUpperCase(), "remark");
            return (Criteria) this;
        }

        public Criteria andExtAdditionalInfoLikeInsensitive(String value) {
            addCriterion("upper(ext_additional_info) like", value.toUpperCase(), "extAdditionalInfo");
            return (Criteria) this;
        }

        public Criteria andPlatformidLikeInsensitive(String value) {
            addCriterion("upper(platformId) like", value.toUpperCase(), "platformid");
            return (Criteria) this;
        }

        public Criteria andSourceidLikeInsensitive(String value) {
            addCriterion("upper(sourceid) like", value.toUpperCase(), "sourceid");
            return (Criteria) this;
        }

        public Criteria andEnidLikeInsensitive(String value) {
            addCriterion("upper(enid) like", value.toUpperCase(), "enid");
            return (Criteria) this;
        }

        public Criteria andDeviceLikeInsensitive(String value) {
            addCriterion("upper(device) like", value.toUpperCase(), "device");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}